IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PG_Get_HP_DiaChi]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[PG_Get_HP_DiaChi]
Go

Create Proc PG_Get_HP_DiaChi
@DiaChi nvarchar(200)
As
Begin
	Select  Date_Add,Date_Up,DiaChi,DienGiai,HVTTLineRef,Scrn_Add,Scrn_Up,
	Sys_Stamp = master.dbo.fn_varbintohexstr(Sys_Stamp),User_Add,User_Up, IsChange = 0 
	from HP_DiaChi where DiaChi=@DiaChi
End